create or replace procedure SP_BATTARGETTREE(
       p_cursor       out sys_refcursor        --返回的结果集
)
 is
begin
 open p_cursor for  select obj_ID,obj_Name,p_obj_ID from TB_TREE_TARGET start with p_obj_id=0 connect by prior obj_id=p_obj_id;
end SP_BATTARGETTREE;
